/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package queenb.web.permission.store;

import queenb.net.entitybean.S350;
import java.sql.SQLException;
import java.util.Date;
import java.util.List;
import oracle.jdbc.OracleTypes;
import queenb.net.datacontrol.DataStatement;
import queenb.net.datacontrol.Param;
import queenb.web.util.PackageContants;

/**
 *
 * @author ems
 */
public class S350Store extends S350 {


    public List<S350> listS350L(int pnFH000, int pnFH200, int pnfs200, int pnps250,String pvSV253, String pvLOGIN) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_S350L, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnfs200),
                    new Param(OracleTypes.INTEGER, pnps250),
                    new Param(OracleTypes.CHAR, pvSV253),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        return super.find(dataStatement, S350.class);
    }
    public List<S350> listS350R(int pnFH000, int pnFH200, int pnfs200, int pnps250, String pvLOGIN) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_S350R, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnfs200),
                    new Param(OracleTypes.INTEGER, pnps250),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        return super.find(dataStatement, S350.class);
    }


    public int deleteS350(
                           int pnFS200,
                           int pnFS250,
                           Date pdSD351,
                           String pvLOGIN

            )
            throws SQLException {
        DataStatement updateStatement = new DataStatement(PackageContants.DELETE_S350, OracleTypes.INTEGER, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFS200),
                    new Param(OracleTypes.INTEGER, pnFS250),
                    new Param(OracleTypes.DATE, pdSD351),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        return super.update(updateStatement, null);
    }
    public int updateS350(
                           int pnPS350,
                           int pnFH000,
                           int pnFH200,
                           int pnFS200,
                           int pnFS250,
                           Date pdSD351,
                           Date pdSD352,
                           String pvSV353,
                           int pnSN354,
                           String pvSV355,
                           String pvSV356,
                           String pvSV357,
                           String pvLOGIN,
                           int pnMAINT

            )
            throws SQLException {
        DataStatement updateStatement = new DataStatement(PackageContants.UPDATE_S350, OracleTypes.INTEGER, new Param[]{
                    new Param(OracleTypes.INTEGER, pnPS350),
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFS200),
                    new Param(OracleTypes.INTEGER, pnFS250),
                    new Param(OracleTypes.DATE, pdSD351),
                    new Param(OracleTypes.DATE, pdSD352),
                    new Param(OracleTypes.CHAR, pvSV353),
                    new Param(OracleTypes.INTEGER, pnSN354),
                    new Param(OracleTypes.CHAR, pvSV355),
                    new Param(OracleTypes.CHAR, pvSV356),
                    new Param(OracleTypes.CHAR, pvSV357),

                    new Param(OracleTypes.CHAR, pvLOGIN),
                    new Param(OracleTypes.CHAR, pnMAINT)
                });
        return super.update(updateStatement, null);
    }


}
